A £2.6 million funding boost for the V&A Museum in Dundee is a “real vote of confidence”, the Scottish Secretary has said.