A rare supernova millions of light years away has become so bright it is almost visible with the naked eye.