Small business optimism rose slightly in June but is still hovering close to a historic low as owners confront rampant inflation and a persistent worker shortage.