Sir Elton John said it was a "poignant evening" as he closed out the final show of his mammoth farewell tour in Sweden in spectacular fashion.