Matt Cooper: Sturgeon’s Frankly offers a fascinating trip through modern Scottish history