Sort query results with 'is in' according to input array

I am using a Query with an “is in” filter to get a list of records from a table. I was expecting records to be returned according to the order of the array used from the app, but it looks instead to be sorted by the record numbers in the table.

I think I can create a workaround with the Tables API, but I’d prefer to use a query if possible. Am I missing something? Or should this be a feature request to add a sort method according to the input array for ‘is in’ filters?