Well then first sort by month and then by date, I would do it in mysql this way

Code: SQL
SELECT * FROM emp_profile ORDER BY MONTH(dob),DAY(dob);
 /* MONTH is a function which extracts the month from dob
     DAY is a function which extracts the date from dob
 */

Hope this solves your problem.