An interferometric CO survey of luminous submillimetre galaxies