The ORDER BY clause in DELETE statement is used when a deletion has to take place by in a specified order. The syntax is like this¬†
DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[ORDER BY ...]
ORDER BY clause is specified, the rows are deleted in the order that is specified.