id | date       | value
-----------------------
1  | 2020-01-01 | 1
2  | 2020-01-02 | 2
3  | 2020-01-03 | 3
4  | 2020-01-04 | 4
5  | 2020-01-05 | 5

SELECT
  date,
  value,
  lead(value, 1) over (ORDER BY date)
FROM table
WHERE date >= '2020-01-01' AND date < '2020-01-05'
ORDER BY date

date       | value | lead
-------------------------
2020-01-01 | 1     | 2
2020-01-02 | 2     | 3
2020-01-03 | 3     | 4
2020-01-04 | 4     | null

date       | value | lead
-------------------------
2020-01-01 | 1     | 2
2020-01-02 | 2     | 3
2020-01-03 | 3     | 4
2020-01-04 | 4     | 5