What is the significance of "ORDER BY emp_id ASC" in the following MySQL command?

SELECT emp_id, fname, lnameFROM personORDER BY emp_id ASC;

SELECT emp_id, fname, lnameFROM personORDER BY emp_id DESC;

SELECT emp_id, fname, lnameFROM personORDER BY emp_id;

SELECT emp_id, fname, lnameFROM accountWHERE start_date

SELECT emp_id, emp_nameFROM personORDER BY emp_id, emp_name;

SELECT d.name, COUNT (emp_id) emp_noFROM department d INNER JOIN Employee eON d.dept_id=e.emp_idGROUP BY d.nameHAVING COUNT (emp_id)>2

SELECT emp_id, title, start_date, fname, fed_idFROM personORDER BY 2, 5;

SELECT emp_id, title, start_date, fname, fed_idFROM personORDER BY RIGHT (fed_id, 3);

SELECT emp_id, title, start_date, fname, fed_idFROM personORDER BY LEFT (fed_id, 3);

SELECT e.emp_id, e.fname,e.lname,d.nameFROM employee e INNER JOIN department dON e.dept_id=e.dept_id;

SELECT e.emp_id, e.fname,e.lname,d.nameFROM employee AS e INNER JOIN department AS dON e.dept_id=e.dept_id;