As offshore oil and gas platforms come to the end of their working lives, the remarkable ecosystems beneath the waves come into their own.