I imagine there'll be an exemption like the one that existed pre-EU free movement rules for Irish players; then if Scotland gets in to the EU and the remaining UK doesn't leave it'd become irrelevant anyway - its limits on non-EU players.
I suspect this might happen even if they vote No -...