Over the centuries scientific theories have emerged that rival religious cosmology in terms of ambition and scope. But can science ever truly explain everything?