You cannot upgrade a single application from a suite. You have to upgrade the suite.
FWIW, I think you’re throwing good money after bad to spend that on a version that’s already two upgrades out of date.
Your CS5 license qualifies you for an intro rate for the first year of Creative Cloud.
It’s your call of course.
Would it be possible to refund the monies for the InDesign CS 6 so I can
purchase the CC Standard version?
Bearing in mind that the OP will be locking him/herself into Adobe's new software "Rental' framework. CS6 is the last version of the product to offer a 'perpetual' license.