select * from t;

id name

0 KARL
1 JAMES
2 SIMON
3 MIKE
2 SIMON
2 SIMON
DAVID
MICHAEL

select * from t
order by id asc;

id name

DAVID
MICHAEL
0 KARL
1 JAMES
2 SIMON
2 SIMON
2 SIMON
3 MIKE

select * from t
order by *nvl(id, 1E99)* asc;

id name

0 KARL
1 JAMES
2 SIMON
2 SIMON
2 SIMON
3 MIKE
DAVID
MICHAEL