How likely is Scottish independence from Britain?

As an American, I can see that there’s what appears to be a vocal minority in Scotland pushing for independence, but I genuinely have no understanding of how likely that is to ever actually happen. Is it at least in the realm of possibility, or is it more of a “The South shall rise again” type thing? (No offense intended...