First Minister Nicola Sturgeon said she was the most optimistic she has been in months as she laid out plans to take Scotland out of lockdown.