Mysql double sort

I would like to double sort my user list. Is this possible within one mysql query?

1. sort by activity


2. sort by ID

for example:

1 Jack Active 
 2 Jill Active 
 5 Jens Active  
 3 Harry Inactive 
 4 Larry Inactive 
 6 Luke  Inactive
 

---