I think the point is that clients are not even given the option to think in terms of "page numbers". What's the use case for needing the 100th page of a query

I think the point is that clients are not even given the option to think in terms of "page numbers". What's the use case for needing the 100th page of a query result, that also doesn't allow you to cache the 100th page locally to retrieve it later?