select
    orders.*
from
    (
        select
            o.order_id,
            count( b.bid_id ) as count_bids
        from
            order_table o
        left join
            bids_table b
                on o.order_id = b.order_id
        group by
            o.order_id
        order by
            count_bids
    ) as ordered
join
    order_table orders
        on orders.order_id = ordered.order_id