Some of the sorting options are complex in nature. For these, the
resolver now uses offset pagination rather than keyset.

Changelog: fixed
EE: true
MR: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/83303