The query requires a sort and doesn’t use index key order or query processing changes order it needs to sort.
That is is the case here (multiple IN elements). You can checkout this article for more details https://blog.couchbase.com/offset-keyset-pagination-n1ql-query-couchbase/