Or if you can not add a identity column to the base table, insert the data into a temp table with an identity column and then use the query from...

If you could add an identity column, this query would be simple.

  select *

  from table as t1 join table as t2 on t1.id = t2.id + 1

dw