I have a support case open asking for guidance on this. I let them know this will break the pagination on our forum lists and on other customizations. So far, their only response was "use cursor", but I don't think that's possible. I will update here if I get any better response.
I also wonder how many customers are using offset and don't even know it.
Regarding "I also wonder how many customers are using offset and don't even know it.":
I think A LOT, I have worked on many communities where I have taken over a customized codebase, and I can count the occurrences where CURSOR was used to paginate something on one hand, most use LIMIT/OFFSET...
