New York has been dethroned as the best city to celebrate the New Year, according to a new study.