the user guesses the score of a game, which is about

< table > < thead > < tr > < th > id < / th > < th > team1 (home team scores) < / th > < th > team2 (visiting team scores) < / th > < / tr > < / thead > < tbody > < tr > < td > 1 < / td > < td > 1 < / td > < td > 2 < / td > < / tr > < tr > < td > 2 < / td > < td > 4 < / td > < td > 2 < / td > < / tr > < tr > < td > 3 < / td > < td > 3 < / td > < td > 2 < / td > < / tr > < tr > < td > 4 < / td > < td > 5 < / td > < td > 2 < / td > < / tr > < tr > < td > 5 < / td > < td > 3 < / td > < td > 1 < / td > < / tr > < tr > < td > 6 < / td > < td > 1 < / td > < td > 1 < / td > < / tr > < tr > < td > 7 < / td > < td > 3 < / td > < td > 3 < / td > < / tr > < / tbody > < / table >

if the final result is: 3Rom 1, how can the query be sorted according to the correct result?