Write a SQL query to retrieve the top 10 most frequent diagnoses from a patient database at Massachusetts General Hospital.