Science and art are often considered opposites – so what happens when top practitioners in each field collaborate? The results, finds Stuart Jeffries, can be seismic