Sydney's iconic harbour has been packed out to ring in 2025 with the traditional midnight fireworks.