I'm baffled as to why nobody mentioned the fact that yes, you can force a mod to use any FSO and MediaVPs version you want it to. The former can be done from the Knossos interface and the latter by modifying a couple values in the mod's mod.json file, I'm sure there's plenty of people around who would happily walk you through this simple proccess. Although I warn you: there is no compatibility or freedom from bugs guaranteed. In case of the FSO version, just because you might hit some novel bugs in newer nightlies.
In case of MVPS, it's because while the FSU team did try to attain maximum compatibility, at some point the packages needed a major refactoring and broke most of the mods that defaulted to the newest MediaVPs. Or at a different point in time, the MediaVPs added a couple magnificent weapon variants and subsequently players wanting to launch Blue Planet with the newest MVPS found themselves crashing on startup because the added variants together with all Blue Planet weapons jumped just that little bit over the weapon class limit.
So generally, I definitely want to encourage exploring mods' compatibility with newest MediaVPs - and preferably if everything is seemingly fine, reporting the fact to the mods' developers or whoever manages them on Knossos at given point in time - but beware that things can get more or less broken and don't be afraid to roll back (preferably reporting the bugs to aforementioned people too; helping locate the bugs is very important for mod makers too). Generally, the rule is that the more a mod resembles retail FS2 (less custom assets, scripts ect.), the more likely it is to cooperate well with newer FSO/MVPS.
Edit: Okay, I was wrong, Asteroth already mentioned it. Whatever.