Ex-SNP leader denies ‘thinking of political opportunity’ – and dismisses officials’ discussion of deleted messages as ‘light-hearted’ banter