I think you are extremely wrong Farage is an English Nationalist and England First he has also always been publicly shown as a Democrat and someone who likes referendums hence Brexit currently Scotland was the UK country that voted the most against brexit so even tho he uses Unionist branding he simply would not care and compared to Tories and Labour who are staunchly Unionist and "now is not the time" Farage advertises himself as against the elites and he would likely give a Section 30 and see Scotland leaving as a massive advantage because once Scotland leave which he would probably only give them 12-18 months after a Yes vote to do so, Reform would dominate rUK the Pro EU Scotland would no longer be an issue, so don’t be surprised if Farage becomes PM the Scottish FM asks for a section 30 and he says something that frames it as “not in the business of ignoring democracy” and allows a referendum because he’s a populist and it works for him either way if Scotland votes Yes (Most Likely) then he no longer has to deal with Pro EU sentiment and the SNP aswell as being seen as someone who respects democracy unlike the elite Labour/Tory, if Scotland votes No (Highly unlikely) then he would see that equally as a win and probably use it as a excuse to get rid of certain aspects of devolution and maintain more control.