create table app_idx (
    id int,
    priority int,
    constraint pk_app_idx primary key (id)
);

insert into app_idx values(1, 1);
insert into app_idx values(2, 2);
insert into app_idx values(3, 3);
insert into app_idx values(4, 4);
insert into app_idx values(5, 5);
insert into app_idx values(6, 6);
insert into app_idx values(7, 7);
insert into app_idx values(8, 8);
insert into app_idx values(9, 9);

ID     PRIORITY
1      1
2      2
9      9
8      8
3      3
4      4
7      7
6      6
5      5