Scientists have solved the mystery of an unusual circular structure beneath the North Sea that has been debated for more than two decades.