Mikal Mahdi admitted to shooting Orangeburg Officer James Myers eight times before burning his body in a shed in 2004