Is it only me or this is what's happening?
I just want to get all posts starting from a certain offset, like 10. Instead I get all posts starting from the 0.
The workaround is to set posts_per_page to a large number.
This is a limitation of the LIMIT syntax itself: