More than 30 casualties have been brought ashore after a crash between an oil tanker and a cargo ship in the North Sea.