Once-in-a-lifetime huge star explosion to appear in sky