The 26-year-old managed to find the net with this jaw-dropping goal, but then was immediately red card for making an obscene gesture towards the audience