Sir Rod Stewart, 81, had to finish the gig sat down in a chair and used an oxygen tank after almost fainted during a show in the US on Friday night