select
    member_id as 'ID',
    score1 - score2 as 'DIFF'
from
    contest_results
order by
    `DIFF` desc,
    `ID` desc;