Added default order to UserFinder

What does this MR do?

• Added default order to UserFinder and some performance improvements to Users endpoint
• Added also default order to pagination method if no order is present.
• Preloading some relationships in users endpoint to avoid some N+1 problems

Why was this MR needed?

Because when we are paginating users and no order is set each subsequent query is not guaranteed to return items in the same order so weird things could happen during pagination.

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated
• API support added
• Tests added for this feature/bug
• Review
  • Has been reviewed by UX
  • Has been reviewed by Frontend
  • Has been reviewed by Backend
  • Has been reviewed by Database
• Conform by the merge request performance guides
• Conform by the style guides
• Squashed related commits together
• Internationalization required/considered

What are the relevant issue numbers?

Closes #40407 (closed)