Well then first sort by month and then by date, I would do it in mysql this way
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.