Ensure deterministic ordering in pagination

[GianlucaFicarelli]

Description:

The get_many endpoints allow offset pagination with custom ordering.
The order of the records must be always deterministic, also when a custom order is specified, and also when using the default order by creation_date because some records can have the same timestamp.
This is critical, because some records might be returned duplicated and others would be missing.

Acceptance criteria

The results of all the get_many endpoints are sorted by id, besides the requested or default ordering (for example: order by creation_date desc, id).

[juanjosegarcan]

Partially fixed by #350
But still pending #353

[juanjosegarcan]

Included in release 2025.9.3