A late penalty by Sergio Agüero was not enough to save Manchester City from their first defeat of the season