Implement `PaginatedQueryCubit` with a next-page-token approach

[mateuszwojtczak]

Lately we've discussed this offline with @Saancreed. It needs to be specified / implemented on both backend and frontend.

@Saancreed Do we have anything related to this on the backend side? Some docs / JIRA tickets?

Also, I think we can just add it as another implementation instead of replacing the current one.

[Saancreed]

https://learn.microsoft.com/en-us/ef/core/querying/pagination#keyset-pagination

https://www.npgsql.org/efcore/mapping/translations.html#row-value-comparisons

Not much else other than docs above that describe the technique and APIs we'd have to use on the backend to implement this.