I used to boot my fileserver (not a Pi) like that and it worked fine for a number of years until the USB-SATA adapter died. Not sure if you meant an actual purpose-built external SSD but I don't know that I'd trust a home-brewed solution in the long term.