select t.id,
       coalesce(nullif(date, '01-01-1900'),
                lag(date) over (order by id)
               ) as date
from t;