When using a literal offset value, that value should be non-negative.

Bad:

select Id, Name
from Users
order by Name
offset -1 rows
fetch next 1 row only

Good:

select Id, Name
from Users
order by Name
offset 0 rows
fetch next 1 row only