Coronavirus shielding advice will come to an end in August, should infection rates continue to drop, Wales’ chief medical officer has said.