Does total size of the transaction affect confirmation time? Suppose one pays 1 satoshi/byte for their transactions.

Will the confirmation of the two transaction below be different?

A) a transaction of 1 inputs and 1 output (~192 bytes)

B) a transaction of 1000 inputs and 1 output (~148044 bytes)
Yes, but for a different reason than you think. ;)

Transactions bigger than 100,000 bytes are considered non-standard and won't be relayed by most nodes and probably not included by most miners in their block candidates.

Besides that, especially for a transaction paying a thrifty fee, a larger transaction might take longer to confirm. Block templates are by default populated by highest fee rate first as this maximizes revenue. It's more likely to have 192 bytes of block space left than 148,044 bytes after all transactions with higher fee rates have been considered. It's thus more likely for a bigger transaction to be delayed from inclusion in a block due to taking up more space.