What happens to deleted texts on iCloud?
I want to tell you that the text is deleted from iCloud. 
First, if your iPhone is charging, using wifi and iCloud has enough space for your iPhone to back up the text, the text would had been backed up. And then you set the manual backup, so the text data has been overwritten by new data.