Overview: Skip and Take with Order by is not returning the correct result.

Replication Steps:
First Panel:
Display “Test Data” list without any filters applied.

Second Panel:
Display the same “Test Data” list.
With filter: Order By Firstname (Ascending).

Below the 2nd panel you will see a button:
Click the button “Copy data” this will trigger to copy the data from source list "Test data" to destination list.
The process uses Skip: 35 and Take: 5.
Observe the output shown in the panel text after execution.

Expected Result:
The system should return the correct records based on ORDER BY Firstname (ASC), then apply Skip 35 and Take 5.
Expected source IDs: (25, 19, 23, 6, 29).

Actual Result:
The returned result does not match the expected Skip and Take behavior when combined ORDER BY.