Scientists have confirmed that the Silverpit Crater in the North Sea was caused by an asteroid impact over 40 million years ago, ending years of controversy over its origin.