Fetching event reports can be slow

[matrixbot]

This issue has been migrated from #16619.

---

E.g. from Jaeger:

My money is on LIMIT ... OFFSET ... being slow. I wonder if we could change this to paginate without OFFSET using the id column? (I assume that received_ts increases as id increases, and vice versa).