SELECT id, order_id, max(amount) as amount FROM `nome_tabella` group by order_id order by id asc



Ciao!