Commemorations of the 200th anniversary of the Battle of Trafalgar ended with a spectacular fireworks display on the Solent at Portsmouth.