As explained here: https://docs.cozy.io/en/tutorials/data/advanced/#indexes-performances-and-design , the index order matters when there is a mix of equality and range predicates: equality should come first.
This could be an integrity check by cozy-client to prevent design mistakes