How to reorder mysql table rows after delete row a single row i am not talking about ALTER_TABLE

how to reorder mysql table rows after delete row a single row i am not talking about ALTER_TABLE