Allan Massie: Scottish optimism should be tempered with caution