create table kdsort (kunde int, nummer int);
insert into kdsort values(50, 1);
insert into kdsort values(1, 2);
insert into kdsort values(10, 3);
...
insert into kdsort values(5, 6);

select * from ...
join kdsort on kdnr = kunde

order by nummer