Celebrations erupted throughout the capital Riyadh after the final whistle blew