The octopus blessed with an uncanny knack of predicting football results, has died at a German aquarium.