MSI Z170A GAMING M7 Coffee-Lake Mod questions

I’m planning on upgrading from my 6700k to a Coffee-Lake CPU but I’m not sure exactly which one.
So, if my information are correct, the 9700/k/kf is the best CPU that can work with this bord? I’ve read that the MSI Bords have a 8 thread lock, so I guess a 9900k wouldn’t work.
Is this still valid in 2021? If yes, is there really no possibility that this will work in the future?