Alex McLeish says Scotland manager role is a ‘tremendous honour’