Query/Test: add tests for ordering collections and composite keys

[maumar]

from query team chat:

collection ordering scenarios to consider
• Collection themselves have orderings, each of them coming from different pattern. There are "if"s in the code which covers many scenarios, ordering from a subquery, ordering from rownumber expression etc.
• Composite keys
• combination of above
• collection on same level vs nested level and their combinations