What happens if I load last 10 rows then next 10 after other rows are inserted?
And that is one of 3 problems with using OFFSET for "pagination".

The other two are


What is some rows were deleted?
Performance.


The solution to all of them is to "remember where you left off".  Here is my blog on the issues.

Most people who use OFFSET come to this forum bemoaning poor performance.  Not many have (yet) discovered the "bug" you are pointing out.