create table students (
    id int auto_increment,
    name varchar(30) not null,
    grade tinyint not null,
    primary key (id)
);

insert into
    students (name, grade)
values
    ('Ryan', 3),
    ('Joanna', 4),
    ('Wanda', 5),
    ('June', 1),
    ('Jack', 3),
    ('John', 3),
    ('Joe', 3),
    ('Cody', 4),
    ('Matt', 1),
    ('Oliver', 2),
    ('David', 5),
    ('Albert', 5),
    ('Andre', 4),
    ('Pablo', 3),
    ('Jorge', 1);

select
    *
from
    students
order by case when grade=3 then -1 else grade end;