SELECT id,
SUM(value) OVER(
  ORDER BY id
  ROWS BETWEEN UNBOUNDED PRECEDING AND 1 FOLLOWING
) AS sum
FROM Example.Data
ORDER BY id;