Database cache: sort result similar to api response

[duyp]

As we supports database cache if no network connection, we need to show the result somehow the same or at least similar to the api response by query sorting: ORDER BY WHAT?