Index not hit on very simple ORDER BY N1QL query

SQL++
2

To pick the index leading key of index needs to be part of query predicate.
Try the following.

explain select * from products WHERE autocompleteMacroRankingPosition IS NOT MISSING ORDER BY autocompleteMacroRankingPosition ASC limit 7;