Megagauss magnetic fields in ultra-intense laser generated dense plasmas