To retrieve records in the same order as they appear in a specific table view, you can pass in the "view" parameter in the list records request (see the API docs).

Additionally, you can filter and sort records by passing in the "filterByFormula" parameter. See here for an example of this.