Table Ordering depends on which column?

[alkuhlani]

As we know the child table, for example, this one,:

I would like to make SQL query to select the items with the same ordering, I tried to order by idx, but it does not help.