1 way is just to add a Sort field to the response datatype (integer), and use that for your sorting…
Another way, is to use the ListShifter plugin, which will allow you to sort a datatype by a value on a connected datatype, as explained here:
Sorting according to a Thing’s Thing field - Idea - Bubble Forum