offset n rows fetch next m rows only with dummy order by column - consistent results?

Question

the "Offset n rows fetch m rows only" clause only works with an specified "order by" - which of course makes the query slower than without order.

My co-worker and me tried ordering by a constant:

select 0 as SORT_DUMMY, p.* from table p order by 1 Offset 0 rows fetch next 10 only

the command runs without Problems, however - I am not sure, if this would return the rows in a reproducable manner (we are using this for pagination).

Anybody has any insights on this?

Regards

Johannes Colmsee