Before reporting an issue

[x] I have read and understood the above terms for submitting issues, and I understand that my issue may be closed without action if I do not follow them.

Area

core

Describe the bug

When the admin UI retrieve a user's events, the DB would need to return them ordered. So making it part of the index is preferred.

Version

main

Regression

[ ] The issue is a regression

Expected behavior

Index should provide ordered list of events

Actual behavior

DB needs to sort all events of the user

How to Reproduce?

Look at DB index

Anything else?

I'll create a PR. This is a follow-up on #26999