Do I need to pay to get full version of HSO instruments set?

Once you’ve activated a trial version, I’m not sure you can activate it again in a new version of Cubase.

If you purchased a license (whether in C5, C6, or C7), then you’re all set.