Pagination conflicts with data sorting

[adrienlauer]

Data sorting in repositories is handled by an option that applies on the whole query but when pagination is involved, it means that sorting is only applied to the current page.

This is clearly not desirable and sorting woud better be viewed as a specification itself so we can apply it not only to the whole specification but also to a subset of it.