Scientists believe they have discovered the site of the biggest meteorite impact ever to hit the British Isles.