Backing singer to the greats of 1960s soul, Scott released one exceptional album – and vanished without trace. Forty-eight years later she’s back with a worthy successor